UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SCJWRI+0aLLq2MX6V9Js65Wv5SA23Zqjy6cD5pIs3uk='
WHERE
key_id = '27d2cb48e0c4879ab55195cbf048106419be6844f6b2eceaac9efcb042bc8e3c'
AND (
token = 'SCJWRI+0aLLq2MX6V9Js65Wv5SA23Zqjy6cD5pIs3uk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)