UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KoEX0uShehbQdoDzZkriIgHh1xVAkNxccLxmRcoqvjY='
WHERE
key_id = '57c271b7149197b6f6e151cb6d9ccda174b723a467d42e66b59cfab302f3bfc6'
AND (
token = 'KoEX0uShehbQdoDzZkriIgHh1xVAkNxccLxmRcoqvjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)