UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H2M1tDpdDpbpN6q558fgMSBzwfG6/gbzS7wyNcp7VN8='
WHERE
key_id = 'c7b6ddbbbf393ecc66f3b183295c0b0ee1801147889f7a270b312b9877111926'
AND (
token = 'H2M1tDpdDpbpN6q558fgMSBzwfG6/gbzS7wyNcp7VN8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)