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