UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xXAmU+pud3MOyxS4l1jiYNp+sEXrWioSZhwzpfzqxb4='
WHERE
key_id = 'b3788fe9c3c32079a6b492eb31d9a81266baad9ceadf4c88ef5f6625b5748247'
AND (
token = 'xXAmU+pud3MOyxS4l1jiYNp+sEXrWioSZhwzpfzqxb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)