UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mcSVpMWrl8KkvCxR0Q0lqzw6+A+L9JXYqyuFhWZyJL0='
WHERE
key_id = 'acfd6fdb95815a26f3e83ef2df86fca140a823e21b708e95f7535525be13f9bd'
AND (
token = 'mcSVpMWrl8KkvCxR0Q0lqzw6+A+L9JXYqyuFhWZyJL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)