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