UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6nEiQypOgPvm0/Gqk0c4y4ajTF4kiRoP5NkFwirqvyM='
WHERE
key_id = '00c9299d6055726e959a9693ff3a66fa8353865595adb8f32a25869be327354e'
AND (
token = '6nEiQypOgPvm0/Gqk0c4y4ajTF4kiRoP5NkFwirqvyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)