UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3zs48Jj5R+XUrmfkdsvJcf6YnjhiyNAARKh+crw95V0='
WHERE
key_id = 'fe1ca84f061a598751b7e6ed51e1fcf1098a2a9079d16bd6a0771c5e2072f011'
AND (
token = '3zs48Jj5R+XUrmfkdsvJcf6YnjhiyNAARKh+crw95V0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)