UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1aLYQ9YbrNdc6dBoT8vItN9h4L6DLtclAoJx76Q16QQ='
WHERE
key_id = 'ebf7acacb705f7f8b81c69def12c41aaea103fc9fb338f3d64abb690d2f83010'
AND (
token = '1aLYQ9YbrNdc6dBoT8vItN9h4L6DLtclAoJx76Q16QQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)