UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HUsKZ5YP7QPSLohTPR+7O/1DtVBq8l8CzLwjCWsEiN4='
WHERE
key_id = '64a4ac69cd566a1c1c2c4b7f4cc0cbe7d3b1b9de6c4613d52693d852198ccfb2'
AND (
token = 'HUsKZ5YP7QPSLohTPR+7O/1DtVBq8l8CzLwjCWsEiN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)