UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qN0UbIzrcwTpjWKUd5yQ5v9b0HJ+DcU5CRP7RsTb6y4='
WHERE
key_id = '04ff2311a43bb247d1b3dc20530092d84b7472afbfb4f2a9da615d76a27ee93c'
AND (
token = 'qN0UbIzrcwTpjWKUd5yQ5v9b0HJ+DcU5CRP7RsTb6y4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)