UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LUfaus7GE6OcjjQ0gj2By5rURyHRyaQOzNQS7aBN3J4='
WHERE
key_id = '786f7fdb5c4339ad5161134cc4b80d76610c1eb66b1b75c6a5db308624dc363e'
AND (
token = 'LUfaus7GE6OcjjQ0gj2By5rURyHRyaQOzNQS7aBN3J4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)