UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9pjEprlQioguwKMStRzl2sBfjwjgQXtIied/kJENCU='
WHERE
key_id = '19c246dd36b300000febf34142ec2ea11ca7402f7339acb55ba21363d5f44329'
AND (
token = 'N9pjEprlQioguwKMStRzl2sBfjwjgQXtIied/kJENCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)