UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sAqN1ElHVfDFuh9RINaY07yNZpImjFFU3ZPpLaKDKzM='
WHERE
key_id = 'efe07a0c40c705bfbb81c56ab13fbb6ad01404557262de47bac6fc7eff37f480'
AND (
token = 'sAqN1ElHVfDFuh9RINaY07yNZpImjFFU3ZPpLaKDKzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)