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