UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y30fkCGZ8sEfWjYqDWsSbIYn3uNnTyBcx9x0uVOIx9c='
WHERE
key_id = '4604b9c3d2d65d049141e88ea8733c5c074a8e9789226822f4367acf2e7d9067'
AND (
token = 'Y30fkCGZ8sEfWjYqDWsSbIYn3uNnTyBcx9x0uVOIx9c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)