UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oIvkicR7hYLXnFM1lijWq6aZ51Lgm5AQc9sQCdNJhhc='
WHERE
key_id = 'd604e7cc7e7583c54c1184ae5732f910a8646001dead2df759c1824c406247d5'
AND (
token = 'oIvkicR7hYLXnFM1lijWq6aZ51Lgm5AQc9sQCdNJhhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)