UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sFPgpv87RPJuRMlzLrIL0cpat1gYxwqufv4oJJ+r8z8='
WHERE
key_id = 'df89edf060861e7eff5899cae68a134ca9a5241b865b7c36320303fb39fb0a07'
AND (
token = 'sFPgpv87RPJuRMlzLrIL0cpat1gYxwqufv4oJJ+r8z8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)