UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ydu/tN78D2656EvlbkRT8i8Bhm01+eeOjk456D3jm+s='
WHERE
key_id = '7817baee6a55f2b3b0fefed32447ee9cbf8da9843471ffb14b3d4baea323eb79'
AND (
token = 'ydu/tN78D2656EvlbkRT8i8Bhm01+eeOjk456D3jm+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)