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