UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TLdzldbKRJRAVroFPSHSvJGwlUx0z8OjGhXo78HpA94='
WHERE
key_id = '7fd1a69cb3cf484fc97104a1ba04ff670d7cd5b83170567dd0a9d6c1caf11b08'
AND (
token = 'TLdzldbKRJRAVroFPSHSvJGwlUx0z8OjGhXo78HpA94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)