UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8xW8nP8h7vM2r7nhKYWmwv/06oeMpWzVFtWmXjFCXA='
WHERE
key_id = 'abf32cd1801ca2c62bf5192cf279804b27b1dafb9c849aa164b981afcddf8b13'
AND (
token = 'X8xW8nP8h7vM2r7nhKYWmwv/06oeMpWzVFtWmXjFCXA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)