UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/8N4tFBK55iCuNMKpMo9pTTOHZ/rUPtT7yg5hpkUQXo='
WHERE
key_id = '02a8bfb2438979a425dd46e90f1a5fd1e1d04d506cff3d6a0bab7ba9f193c12f'
AND (
token = '/8N4tFBK55iCuNMKpMo9pTTOHZ/rUPtT7yg5hpkUQXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)