UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UUWmQdgGuX4cVN0BRqlctOSi1KE1zwykywgaCHLVUyM='
WHERE
key_id = 'a12eb10f3b2a865f619c29735f8f824145f29204aa9365d73ac3e1194d2d66c6'
AND (
token = 'UUWmQdgGuX4cVN0BRqlctOSi1KE1zwykywgaCHLVUyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)