UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ooUd4dupGQJD4QZzPYU1N1GHwIXIWtwPS3o1GkcIwWE='
WHERE
key_id = '14328ab7901aae9a61e65cf6b2bfbe630bf0bd0e2e5ede584aa93be3abf34854'
AND (
token = 'ooUd4dupGQJD4QZzPYU1N1GHwIXIWtwPS3o1GkcIwWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)