UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BKQ6F68/FlhS361Xrj6/xKQ0pJxuLuF/9pDHE2J6Lpw='
WHERE
key_id = 'fbab7159667c0a743f402c8c40090eeb924f0bcbf5c0b664e3afdd87717a666f'
AND (
token = 'BKQ6F68/FlhS361Xrj6/xKQ0pJxuLuF/9pDHE2J6Lpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)