UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/mVs5p38iSNJU/a8VvZR2Oqre9BlxLlqFRBjvBWr/0g='
WHERE
key_id = '08d29c1767541aaf3178e04fe46d8eea921d38ca0487ad39c13195cebe0be549'
AND (
token = '/mVs5p38iSNJU/a8VvZR2Oqre9BlxLlqFRBjvBWr/0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)