UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5oHWu2JS4LXvZvH4AmQkmgRaiwfmr9XSMvfBMtPJzVc='
WHERE
key_id = 'bdd5882930fcb1bdc94f8768c7949c99b78c157717e91357daa549b9e77610bd'
AND (
token = '5oHWu2JS4LXvZvH4AmQkmgRaiwfmr9XSMvfBMtPJzVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)