UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vWem4+o8OhGvCtMYpAYFatYao+KTzcXCSf4dY4PVj40='
WHERE
key_id = '501b86b58276ac9b2db86ca63ab4dce55f98ce405ed6c3130cedf754d26a0af7'
AND (
token = 'vWem4+o8OhGvCtMYpAYFatYao+KTzcXCSf4dY4PVj40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)