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