UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tI/9vu7GuGjJZxGMN5gcnsCOU4N18YxybK8WKfAm3DU='
WHERE
key_id = '7ea984d3d532134b07ad6df776a973f96afb62f3f529b1f7e571a93f47c44585'
AND (
token = 'tI/9vu7GuGjJZxGMN5gcnsCOU4N18YxybK8WKfAm3DU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)